CREATE TABLE `qfcy_rewardcfg` (
	`id` SMALLINT(5) NOT NULL AUTO_INCREMENT,
	`reward_id` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '奖品分组',
	`reward_name` VARCHAR(60) NOT NULL DEFAULT '' COMMENT '奖品名称',
	`item_idb` VARCHAR(16) NOT NULL DEFAULT '0' COMMENT '物品ID男',
	`item_idg` VARCHAR(16) NOT NULL DEFAULT '0' COMMENT '物品ID女',
	`item_name` VARCHAR(30) NOT NULL DEFAULT '' COMMENT '物品名称',
	`reward_pay` MEDIUMINT(6) NOT NULL DEFAULT '0' COMMENT '花费数量',
	`use_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '物品类型',
	`use_day` INT(11) NOT NULL DEFAULT '0' COMMENT '时长/数量',
	`reward_picb` VARCHAR(128) NOT NULL DEFAULT '',
	`reward_picg` VARCHAR(128) NOT NULL DEFAULT '',
	`reward_type` TINYINT(1) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

CREATE TABLE `qfcy_giftlog` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`uin` INT(11) NOT NULL,
	`zone_id` INT(11) NOT NULL,
	`uin_new` INT(11) NOT NULL,
	`zone_id_new` INT(11) NOT NULL,
	`account` VARCHAR(100) NOT NULL,
	`ip` VARCHAR(50) NOT NULL,
	`gift_type` VARCHAR(10) NOT NULL,
	`gift_name` VARCHAR(100) NOT NULL,
	`item_name` VARCHAR(100) NOT NULL,
	`item_man_id` VARCHAR(100) NULL DEFAULT NULL,
	`item_women_id` VARCHAR(100) NULL DEFAULT NULL,
	`status` INT(11) NOT NULL DEFAULT '0',
	`create_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`gift_num` INT(11) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

CREATE TABLE `qfcy_signinfo` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`uin` INT(11) NOT NULL,
	`zone_id` INT(11) NOT NULL,
	`account` VARCHAR(150) NOT NULL,
	`ip` VARCHAR(50) NOT NULL,
	`sign_info` TEXT NULL,
	`create_time` DATETIME NOT NULL,
	`last_modify_time` DATETIME NOT NULL,
	`userjf` INT(20) NOT NULL DEFAULT '0',
	`signday` INT(20) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;

CREATE TABLE `qfcy_signlog` (
	`sign_day` INT(11) NOT NULL,
	`uin` INT(100) NOT NULL,
	`zoneid` INT(100) NOT NULL,
	`ip` VARCHAR(100) NOT NULL,
	`status` INT(11) NOT NULL DEFAULT '0',
	`create_time` DATETIME NOT NULL,
	`userjf` INT(20) NOT NULL DEFAULT '0',
	PRIMARY KEY (`sign_day`, `uin`, `zoneid`)
)
COLLATE=utf8_general_ci
ENGINE=InnoDB;